select ten_khoa, count(ma_sv), min(tuoi), max(tuoi) from khoa, lop, sv where khoa.ma_khoa = lop.ma_khoa and lop.ma_lop = sv.ma_lop and que_quan = 'Da Nang' group by ten_khoa
D:\testmvgen
mv1
mv1
QLSV
postgres
208811